package com.hawthorn.redis.repository.provider;

import org.apache.ibatis.builder.annotation.ProviderMethodResolver;

/**
 * <p>todo todo 字典缓存sql类</p>
 * @author: andyten@tom.com | xukaixing@hotmail.com
 * @created: 2021/11/28 4:59 PM
 * @version v1.0.1
 * @copyright: Copyright (c)  andyten
 */
public class DictCacheSqlProvider implements ProviderMethodResolver
{
  public static String selectDict()
  {
    String sql = "select " +
        "id, " +
        "dic_code, " +
        "label, " +
        "label_en, " +
        "parent, " +
        "type, " +
        "spell, " +
        "aspell, " +
        "sort " +
        "from sys_dict " +
        "where del_flag = 0 " +
        "order by parent,sort,dic_code,label";
    return sql;
  }
}
